﻿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!--DXMETADATA start type="MetaCharset" --><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><!--DXMETADATA end-->
    <meta http-equiv="X-UA-Compatible" value="IE=9" />

    <!--DXMETADATA start type="Literal" condition="helpversion:value=3" value="<meta name=""Microsoft.Help.SelfBranded"" content=""true"" />" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<title>%%ProjectTitle%% - %%ItemTitle%%</title>" --><title>SpreadJS ReadMe - Release Notes for Version 11.0.0</title><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<meta name=""Title"" content=""%%ProjectTitle%% - %%ItemTitleNoQuotes%%""/>" --><meta name="Title" content="SpreadJS ReadMe - Release Notes for Version 11.0.0"/><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="jquery" filetype="script" firstlinkattributes="id=""mshs_support_script"""--><script src="template/packages/jquery/script/default/jquery-1.11.3.min.js" type="text/javascript" id="mshs_support_script"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="script"--><script src="template/packages/jquery-ui/script/default/jquery-ui-1.11.4.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/jquery-ui/css/default/jquery-ui-1.11.4.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="TemplateSettingsJson" format="<script type=""text/javascript"">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:%%TemplateSettingsJson%%});</script>" --><script type="text/javascript">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:{"dynamictoc":{"initialNodeId":"n15","initialNodeContainer":"c0","isResizable":true},"inthistopic":{"isEnabled":true},"currentLocale":"-","isFrameless":true,"navigationKind":"inpage","versions":{"locale":{"currentId":"-"}}}});</script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="light" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/light/css/dynamic-toc.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="Synopsis" StripHtmlTags="True" MaxLength="250" format="<meta name=""Description"" content=""%%Synopsis%%"" />"--><meta name="Description" content="Enhancements from the Previous Release

The following features have been added with this version of the product." /><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/plugins-topics/css/default/jquery-plugins.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="css" firstlinkattributes=" data-mshv2-stylesheet=""/template/packages/core-topics/topics.mshv2.css"" data-mshv1-stylesheet=""/template/packages/core-topics/topics.mshv1.css"" data-responsive-mobile=""template/packages/core-topics/topics.mobile.css"" data-responsive-tablet=""template/packages/core-topics/topics.tablet.css"""--><link rel="stylesheet" type="text/css" href="template/packages/core-topics/css/topics.css"  data-mshv2-stylesheet="/template/packages/core-topics/topics.mshv2.css" data-mshv1-stylesheet="/template/packages/core-topics/topics.mshv1.css" data-responsive-mobile="template/packages/core-topics/topics.mobile.css" data-responsive-tablet="template/packages/core-topics/topics.tablet.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="script"--><script src="template/packages/plugins-topics/script/default/jquery-plugins.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="script"--><script src="template/packages/core-topics/script/topics.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="TopicId" format="<meta name=""Microsoft.Help.Id"" content=""%%TopicId%%""/>" --><meta name="Microsoft.Help.Id" content="b62cc050-f647-4d55-9cf3-9145fedb11a4"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocParentId" format="<meta name=""Microsoft.Help.TocParent"" content=""%%TocParentId%%""/>" --><meta name="Microsoft.Help.TocParent" content="80753e0a-efcf-407b-89ce-337c2fd3b27e"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocOrdinal" format="<meta name=""Microsoft.Help.TocOrder"" content=""%%TocOrdinal%%""/>" --><meta name="Microsoft.Help.TocOrder" content="7"/><!--DXMETADATA end-->
    <meta name="Microsoft.Help.F1" content=""/>
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <!--DXMETADATA start type="MshvKeywords" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="MshvMetaTags" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.Locale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.TopicLocale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Stylesheets" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="StylePropertyValues" format="<style>%%StylePropertyValues%%</style>" --><style>.i-is-new .i-page-title-text::after, ul#i-dt-root li.i-is-new>a::after { content: "New" }
</style><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scripts" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="DesignTime"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end -->
    <!--DXMETADATA start type="CustomHeadContent" --><link rel="stylesheet" type="text/css" href="template/packages/core-web/css/SP.css">
<script type="text/javascript">
var currentHeader = function() {
    return "spjsreadme";
}
</script>
<script src="template/packages/core-web/script/topNavigation.js"></script>
<script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-WT462SJ"></script>
<script>
        (function (w, d, s, l, i) {
            w[l] = w[l] || [];
            w[l].push({
                'gtm.start': new Date().getTime()
                , event: 'gtm.js'
            });
            var f = d.getElementsByTagName(s)[0]
                , j = d.createElement(s)
                , dl = l != 'dataLayer' ? '&l=' + l : '';
            j.async = true;
            j.src = 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
            f.parentNode.insertBefore(j, f);
        })(window, document, 'script', 'dataLayer', 'GTM-WT462SJ');
    </script>

<!--DXMETADATA end-->
</head>

<body>
    <div id="i-before-header-content" class="i-before-header-content">
        
    </div>

    <div id="i-header-container">
        <div id="i-header-content" class="i-header-content i-content-width-container">
            <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end-->
            <div class="i-project-title"><!--DXMETADATA start type="ProjectTitle" -->SpreadJS ReadMe<!--DXMETADATA end--></div>
            <div class="i-search-container">
                <!--DXMETADATA start type="outputfileextension" format="<form action=""websearch%%outputfileextension%%"">" --><form action="websearch.html"><!--DXMETADATA end-->
                <input id="i-search" name="query"/>
                <input type="submit" id="i-search-button" value=""/>
                <!--DXMETADATA start type="Literal" value="</form>" --></form><!--DXMETADATA end-->
            </div>
            <!--DXMETADATA start type="outputfileextension" format="<a id=""i-index-button"" href=""webindex%%outputfileextension%%""></a>" --><a id="i-index-button" href="webindex.html"></a><!--DXMETADATA end-->
        </div>
    </div>
    
    <div class="i-content-width-container"><div class="i-busy-overlay"></div></div>

    <div id="i-breadcrumbs-outer-container" class="i-content-width-container"><!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="i-breadcrumbs-container">
<a href="readme.html">ReadMe</a>
 / <a href="rnotes.html">Release Notes</a>
 / Release Notes for Version 11.0.0</div><!--DXMETADATA end --></div>

    

    <div id="i-actions-outer-container" class="i-content-width-container">
        <div id="i-actions-container">
            <div id="i-actions-content" class="i-fixed-to-top">
                <!-- Spacing --> <span class="i-toggle-all-sections i-function-link">
                <label class="i-collapse-all"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label>
                <label class="i-expand-all" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label>
            </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end -->
                <div class="i-in-this-topic-container">
                    <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
                </div>
            </div>
        </div>
    </div>

    <div id="i-toc-outer-container" class="i-content-width-container">
        <div id="i-toc-container">
            <div id="i-toc-content" class="i-fixed-to-top">
                <div class="i-toc-content-scroll-container">
                    <div id="i-dynamic-toc-container"><ul id="i-dt-root"></ul></div>
                </div>
            </div>
        </div>
    </div>

    <div id="i-body-content-container" class="i-content-width-container">
        <div id="i-body-content" class="i-body-content">
            <div class="i-page-title"><div class="i-page-title-text"><!--DXMETADATA start type="ItemTitle" -->Release Notes for Version 11.0.0<!--DXMETADATA end--></div></div>
            <div class="i-in-this-topic-container">
                <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
            </div>
            <!--DXMETADATA start type="TopicSection" name="BodyText"--><h1>Enhancements from the Previous Release</h1>

<p>The following features have been added with this version of the product.</p>

<ul>
    <li>Widget Features

        <ul>
            <li>The easy outline feature using column indents has been added.</li>

            <li>The Hyperlink cell now supports call back actions.</li>

            <li>The Hyperlink cell now supports word wrap.</li>

            <li>The hitTest method has been added to Spread.</li>

            <li>The SheetMoved and SheetMoving events have been added.</li>

            <li>Vertical alignment is now supported while editing a cell.</li>

            <li>Indenting text now works with Hyperlink cells.</li>

            <li>The suspendDirty, resumeDirty, and isDirtySuspended methods have been added.</li>

            <li>Many new formula functions have been added.</li>

            <li>The allowUserDragMerge option has been added.</li>

            <li>The DragMerged and DragMerging events have been added.</li>

            <li>The accounting format is now supported.</li>

            <li>The OutlineColumn is now supported.</li>

            <li>The export to PDF is now supported.</li>

            <li>The UMD pattern is now supported.</li>

            <li>Eight chart type groups,&nbsp;comprising 28 chart types, have been added. Also provided support for combo chart ability which could combine multi-chart typess in one.</li>

            <li>Context menu has been added to the workbook.</li>
        </ul>
    </li>
</ul>

<h1>Changes from the Previous Release</h1>

<p>This version of the product has the following changes.</p>

<ul>
    <li>The built-in formula editor displays additional colors.</li>

    <li>Using a quote as a prefix to store a string is now supported.</li>

    <li>The NameInfo constructor has an additional parameter.</li>

    <li>The addCustomName method has an additional parameter.</li>

    <li>The Spread schema has been updated.</li>

    <li>The Workbook toJSON and fromJSON methods have additional parameter options.</li>
</ul>

<h1>Resolved Issues</h1>

<p>The following issues have been resolved since the last release.</p>

<ul>
    <li>Cell borders now print correctly when the showBorder method is false.</li>

    <li>Contents of formula TextBox can now be correctly copied. [240268]</li>

    <li>Computational error with formula is no longer observed.&nbsp;[240451]</li>

    <li>Cell lock issue and border width issue are now fixed. [240109]</li>

    <li>RangeChanged event now returns consistent data on pasting a value in a cell and putting formula in the same cell. [241203]</li>

    <li>SelectionChanged event now fires correctly. [227675]</li>

    <li>SetRowVisible now works correctly after importing an excel file with hidden rows. [237749]</li>

    <li>Client ExcelIO now works correctly in IE10. [242866]</li>

    <li>RepeatRow setting now works correctly when setRowPageBreak is used. [242802]</li>

    <li>Formula now displays correctly in tableBind sample. [242737]</li>

    <li>Cursor of float object no longer moves when mouseover locked float object. [243266]</li>

    <li>Copying a cell with "=" value and pasting it to another spread now works correctly. [243264]</li>

    <li>CORREL, SLOPE, and INTERCEPT functions now work correctly in SpreadJS Designer. [243125]</li>

    <li>Importing excel with formulas into SpreadJS Designer no more give formula errors. [243295]</li>

    <li>SpreadJS navigation now works correctly on pressing command+f then arrow key in 64-bit mac chrome. [243947]</li>

    <li>Named ranges do not show error upon exporting .xlsx file from SreadJS Designer. [243875]</li>

    <li>Time to load group on using Spread.SuspendPaint() method is now reduced. [244337]</li>

    <li>Formulas no longer get prefixed with "_xlfn" on importing attached Excel file in SpreadJS [244391]</li>

    <li>Loading an imported excel file with unsupported local id (symbol) no longer throws exception. [242765]</li>

    <li>SpreadJS no more throws exception while exporting excel with printInfo settings containing JP font style to PDF. [232533]</li>

    <li>Formula is now shown correctly and excel file opens without error when the excel file with cross workbook reference is imported to SpreadJS and exported to excel again. [226931]</li>

    <li>Performance of setFormula code is now improved in binding mode. [241002]</li>

    <li>SelectionPolicy.single no longer disables [Tab] key navigation. [241853]</li>

    <li>VALUE() function now gives correct result. [240101]</li>

    <li>Touch resize indicator is no more shown in protected sheet. [242378]</li>

    <li>Exported excel now opens correctly on setting conditional format and exporting to Excel using Excel IO component. [239281]</li>

    <li>Sheet paint suspend status is now correct after reset.&nbsp;[245639]</li>

    <li>The full column condition formula now works correctly on setting SaveBothCustomRowAndColumnHeaders while exporting.&nbsp;[234545]</li>

    <li>Code to update data source now works correctly in Angular sample. [245474]</li>

    <li>Select Range border of a column that is frozen and hidden is now visible. [244536]</li>

    <li>Header cells of SpreadJS can now be correctly copied and pasted to Excel. [246548]</li>

    <li>Contents of cells containing text within '&lt;&gt;' tags can now be correctly copied and pasted to another cell. [245487]</li>

    <li>Contents of cells are now correctly copied from excel file and pasted to Spreadsheet without creating extra spaces. [246214]</li>

    <li>Spreadsheet with formula containing special sheet reference now opens without error in MS Excel 2007. [246452]</li>

    <li>Html content can be correctly copied and pasted to Spreadsheet. [246457]</li>

    <li>ColumnName no longer changes on moving and copying table. [247078]</li>

    <li>Exported excel file now opens correctly in Excel 2007. [246148]</li>

    <li>Imported excel file now retains the column width [246844]</li>

    <li>INDIRECT formulas now work correctly. [245724]</li>

    <li>Performance of filtering and modifying formula has now been improved. [247472]</li>

    <li>Workbook can now be correctly imported into a new sheet in a separate workbook. [247380]</li>

    <li>New annotations can now be correctly saved. [247229]</li>

    <li>Formula can now be updated without error. [247469]</li>

    <li>Formula text box now works correctly while switching sheets.&nbsp;[247572]</li>

    <li>Moving mouse over SpreadJS after calling resumePaint() method no longer gives error. [247296]</li>

    <li>Groups are now properly loaded in SpreadJS. [247565]</li>

    <li>Editing an invalid formula no longer throws exception. [248545]</li>

    <li>Position of frozen line is now correct with hidden rows and columns in the frozen area. [249715]</li>

    <li>Cells that contain different fonts and size characters are now rendered correctly. [249724]</li>

    <li>Complex Formula DataValidation now calculates correctly. [249992]</li>

    <li>Background color now renders correctly on importing custom theme file. [249710]</li>

    <li>User no longer needs to undo pasting on canceling pasting in ClipboardPasting. [248974]</li>

    <li>File exported with SpreadJS no longer gives error. [248770]</li>

    <li>Behavior of SpreadJS is now consistent with&nbsp;MS Excel&nbsp;and sheet can no longer&nbsp;expand group when cell is editing. [245606]</li>

    <li>DataBar rule now works correctly for negative values as well. [248395]</li>

    <li>EditChange event now fires correctly in FireFox with IME input. [248663]</li>

    <li>Value of formula no longer changes on exporting the excel file by client side ExcelIO. [248666]</li>

    <li>Floating objects are now rendered correctly on the exported excel file containing images. [248397]</li>

    <li>Images in the imported excel files are now imported correctly. [249133]</li>

    <li>INDIRECT formula now works correctly in the excel file imported to SpreadJS. [249367]</li>
</ul><!--DXMETADATA end-->
            <a name="seealsobookmark"></a>
            <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><!--DXMETADATA end-->
            
            <div id="i-footer-content" class="i-footer-content">
                <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p>&nbsp;</p><p>&nbsp;</p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p>&nbsp;</p><p>&nbsp;</p><hr style="height: 1px" /><p><p>Copyright © 2019 GrapeCity, Inc. All rights reserved.</p>
<p><a href="https://www.grapecity.com/forums/spread-sheets" target="_blank">Product Support Forum</a> | <a href="javascript:window.print()">Print this page</a></p>
<ul class="social">
<li><a href="https://www.facebook.com/GrapeCityUS/" target="_blank" class="facebook">&nbsp;</a></li>
<li><a href="https://twitter.com/GrapeCityUS" target="_blank" class="twitter">&nbsp;</a></li>
<li><a href="https://www.linkedin.com/company/grapecity" target="_blank" class="linkedin">&nbsp;</a></li>
</ul>
</p><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end-->
            </div>
        </div>
    </div>
        
    <script type="text/javascript">
        $(function () {
            var documentInstance = new Innovasys.Content.Document(document.body);
            documentInstance.load();
        });
    </script>
</body>
</html>
